--exec dbo.set_class_child 0,'lorl', 1,1,34,'looool'  
--exec dbo.get_class_childs 0
create procedure set_class_child   
	@parent int,@name nchar(100),@it bit,@un bit,@max int,@dsc nvarchar(max)
as
INSERT INTO [anton].[dbo].[class]
           ([node_id]
           ,[parent_node_id]
           ,[class_name]
           ,[is_item]
           ,[is_unit]
           ,[max_value]
           ,[desc])
     VALUES
           ((SELECT max( [node_id] ) FROM [anton].[dbo].[class]) + 1
           ,@parent
           ,@name
           ,@it
           ,@un
           ,@max
           ,@dsc)



 